USE Contacts
GO
IF (OBJECT_ID('Select_Contact')IS NOT NULL)
DROP VIEW Select_Contact
GO

CREATE VIEW Select_Contact
AS 
	SELECT  Personality.PersonalityLastName,
		Personality.PersonalityFirstName,
		Personality.PersonalityPatronymic,
		Personality.PersonalitySex,
		Personality.PersonalityMobilePhone,
		Personality.PersonalityInternalPhone,
		Personality.PersonalityEMAIL,
		Personality.PersonalityPhoto,
		PlaceResidence.PlaceResidenceCity,
		PlaceResidence.PlaceResidenceStreet,
		PlaceResidence.PlaceResidenceHome,
		PlaceResidence.PlaceResidenceFlat,
		Position.PositionName,
		Subdivision.SubdivisionName,
		Personality.PersonalityAdditionalInformation
	FROM  Personality
INNER JOIN PlaceResidence
ON Personality.PlaceResidenceID=PlaceResidence.PlaceResidenceID
INNER JOIN Position
ON Personality.PositionID=Position.PositionID
INNER JOIN Subdivision
ON Position.SubdivisionID=Subdivision.SubdivisionID
GO